select
P_News.NewsTitleDsc,
P_News.NewsInCde,
OBJ001.CharVal as CHARVAL_OBJ001,
replace(to_char(to_number(JAN.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Janvier,
replace(to_char(to_number(FEB.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Fevrier,
replace(to_char(to_number(MAR.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Mars,
replace(to_char(to_number(APR.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Avril,
replace(to_char(to_number(MAY.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Mai,
replace(to_char(to_number(JUN.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Juin,
replace(to_char(to_number(JUL.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Juillet,
replace(to_char(to_number(AUG.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Aout,
replace(to_char(to_number(SEP.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Septembre,
replace(to_char(to_number(OCT.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Octobre,
replace(to_char(to_number(NOV.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Novembre,
replace(to_char(to_number(DECE.CHARVAL,'999999999999999.99'),'990.99'),'.',',') as Decembre
from P_NEWS
inner Join R_NewsTyp On P_NEWS.NewstypIncde = R_NewsTyp.NewstypIncde and NewsTypExCde = 'DS001'
inner join P_NEWSCHAR  OBJ001 on P_News.NewsInCde =  OBJ001.NewsInCde 
and  OBJ001.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_CHAROBJ001')      
inner join P_NEWSCHAR  JAN on P_News.NewsInCde =  JAN.NewsInCde and  JAN.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_JAN')
inner join P_NEWSCHAR  FEB on P_News.NewsInCde =  FEB.NewsInCde and  FEB.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_FEB') 
inner join P_NEWSCHAR  MAR on P_News.NewsInCde =  MAR.NewsInCde and  MAR.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_MAR') 
inner join P_NEWSCHAR  APR on P_News.NewsInCde =  APR.NewsInCde and  APR.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_APR')
inner join P_NEWSCHAR  MAY on P_News.NewsInCde =  MAY.NewsInCde and  MAY.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_MAY')
inner join P_NEWSCHAR  JUN on P_News.NewsInCde =  JUN.NewsInCde and  JUN.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_JUN')
inner join P_NEWSCHAR  JUL on P_News.NewsInCde =  JUL.NewsInCde and  JUL.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_JUL')
inner join P_NEWSCHAR  AUG on P_News.NewsInCde =  AUG.NewsInCde and  AUG.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_AUG')
inner join P_NEWSCHAR  SEP on P_News.NewsInCde =  SEP.NewsInCde and  SEP.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_SEP')
inner join P_NEWSCHAR  OCT on P_News.NewsInCde =  OCT.NewsInCde and  OCT.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_OCT')
inner join P_NEWSCHAR  NOV on P_News.NewsInCde =  NOV.NewsInCde and  NOV.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_NOV')
inner join P_NEWSCHAR  DECE on P_News.NewsInCde = DECE.NewsInCde and  DECE.CharInCde = (Select CharInCde from R_Char where CharExcde = 'DS_N02_DEC')